DataGrid Samples |
Quickly populate DataGrids from workbooks without Excel |
|
 |
Workbooks are an excellent source of data for the built-in DataGrid, DataSet and
DataTable components included in the Microsoft .NET Framework, as well as the many
third party charting and other controls which accept a DataSet or DataTable. SpreadsheetGear
for .NET makes it easy to populate a DataSet or DataTable from a workbook or worksheet
range, as demonstrated by these samples. |
|
Spreadsheet to DataGrid |
Retrieve data from a workbook and display it in a DataGridView control. |
|
Spreadsheet to DataGrid with Formats and Formulas |
Insert data from a DataTable into a workbook, merging the data with formatting and
formulas. The results are displayed in a DataGridView control. |
|